package cn.whdream.mapper.sqlsqerver.ehaipost.dbo;

import static cn.whdream.mapper.sqlsqerver.ehaipost.dbo.AccountDynamicSqlSupport.*;
import static org.mybatis.dynamic.sql.SqlBuilder.*;

import cn.whdream.test.entity.ehaipost.dbo.Account;
import java.util.List;
import javax.annotation.Generated;
import org.apache.ibatis.annotations.DeleteProvider;
import org.apache.ibatis.annotations.InsertProvider;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Result;
import org.apache.ibatis.annotations.ResultMap;
import org.apache.ibatis.annotations.Results;
import org.apache.ibatis.annotations.SelectProvider;
import org.apache.ibatis.annotations.UpdateProvider;
import org.apache.ibatis.type.JdbcType;
import org.mybatis.dynamic.sql.SqlBuilder;
import org.mybatis.dynamic.sql.delete.DeleteDSL;
import org.mybatis.dynamic.sql.delete.MyBatis3DeleteModelAdapter;
import org.mybatis.dynamic.sql.delete.render.DeleteStatementProvider;
import org.mybatis.dynamic.sql.insert.render.InsertStatementProvider;
import org.mybatis.dynamic.sql.render.RenderingStrategy;
import org.mybatis.dynamic.sql.select.MyBatis3SelectModelAdapter;
import org.mybatis.dynamic.sql.select.QueryExpressionDSL;
import org.mybatis.dynamic.sql.select.SelectDSL;
import org.mybatis.dynamic.sql.select.render.SelectStatementProvider;
import org.mybatis.dynamic.sql.update.MyBatis3UpdateModelAdapter;
import org.mybatis.dynamic.sql.update.UpdateDSL;
import org.mybatis.dynamic.sql.update.render.UpdateStatementProvider;
import org.mybatis.dynamic.sql.util.SqlProviderAdapter;

@Mapper
public interface AccountMapper {
    @Generated("org.mybatis.generator.api.MyBatisGenerator")
    @SelectProvider(type=SqlProviderAdapter.class, method="select")
    long count(SelectStatementProvider selectStatement);

    @Generated("org.mybatis.generator.api.MyBatisGenerator")
    @DeleteProvider(type=SqlProviderAdapter.class, method="delete")
    int delete(DeleteStatementProvider deleteStatement);

    @Generated("org.mybatis.generator.api.MyBatisGenerator")
    @InsertProvider(type=SqlProviderAdapter.class, method="insert")
    int insert(InsertStatementProvider<Account> insertStatement);

    @Generated("org.mybatis.generator.api.MyBatisGenerator")
    @SelectProvider(type=SqlProviderAdapter.class, method="select")
    @ResultMap("AccountResult")
    Account selectOne(SelectStatementProvider selectStatement);

    @Generated("org.mybatis.generator.api.MyBatisGenerator")
    @SelectProvider(type=SqlProviderAdapter.class, method="select")
    @Results(id="AccountResult", value = {
        @Result(column="acct_id", property="acctId", jdbcType=JdbcType.CHAR, id=true),
        @Result(column="sub_acct_id", property="subAcctId", jdbcType=JdbcType.CHAR),
        @Result(column="name", property="name", jdbcType=JdbcType.VARCHAR),
        @Result(column="temp_st_no", property="tempStNo", jdbcType=JdbcType.INTEGER),
        @Result(column="st_name", property="stName", jdbcType=JdbcType.VARCHAR),
        @Result(column="suite", property="suite", jdbcType=JdbcType.VARCHAR),
        @Result(column="city", property="city", jdbcType=JdbcType.CHAR),
        @Result(column="state", property="state", jdbcType=JdbcType.VARCHAR),
        @Result(column="zip", property="zip", jdbcType=JdbcType.CHAR),
        @Result(column="sub_zip", property="subZip", jdbcType=JdbcType.INTEGER),
        @Result(column="attention_1", property="attention1", jdbcType=JdbcType.CHAR),
        @Result(column="attention_2", property="attention2", jdbcType=JdbcType.CHAR),
        @Result(column="attention_3", property="attention3", jdbcType=JdbcType.CHAR),
        @Result(column="attention_4", property="attention4", jdbcType=JdbcType.CHAR),
        @Result(column="phone_1", property="phone1", jdbcType=JdbcType.VARCHAR),
        @Result(column="phone_2", property="phone2", jdbcType=JdbcType.CHAR),
        @Result(column="phone_3", property="phone3", jdbcType=JdbcType.CHAR),
        @Result(column="phone_4", property="phone4", jdbcType=JdbcType.CHAR),
        @Result(column="ext_1", property="ext1", jdbcType=JdbcType.CHAR),
        @Result(column="ext_2", property="ext2", jdbcType=JdbcType.CHAR),
        @Result(column="ext_3", property="ext3", jdbcType=JdbcType.CHAR),
        @Result(column="ext_4", property="ext4", jdbcType=JdbcType.CHAR),
        @Result(column="fax", property="fax", jdbcType=JdbcType.CHAR),
        @Result(column="www_address", property="wwwAddress", jdbcType=JdbcType.CHAR),
        @Result(column="data_line", property="dataLine", jdbcType=JdbcType.CHAR),
        @Result(column="log_on", property="logOn", jdbcType=JdbcType.VARCHAR),
        @Result(column="password", property="password", jdbcType=JdbcType.VARCHAR),
        @Result(column="priority", property="priority", jdbcType=JdbcType.CHAR),
        @Result(column="pmt_code", property="pmtCode", jdbcType=JdbcType.CHAR),
        @Result(column="pmt_term", property="pmtTerm", jdbcType=JdbcType.INTEGER),
        @Result(column="credit_limit", property="creditLimit", jdbcType=JdbcType.DECIMAL),
        @Result(column="billing_cycle", property="billingCycle", jdbcType=JdbcType.CHAR),
        @Result(column="credit_status", property="creditStatus", jdbcType=JdbcType.CHAR),
        @Result(column="open_date", property="openDate", jdbcType=JdbcType.TIMESTAMP),
        @Result(column="open_comment", property="openComment", jdbcType=JdbcType.VARCHAR),
        @Result(column="close_date", property="closeDate", jdbcType=JdbcType.TIMESTAMP),
        @Result(column="close_comment", property="closeComment", jdbcType=JdbcType.VARCHAR),
        @Result(column="table_id", property="tableId", jdbcType=JdbcType.INTEGER),
        @Result(column="acct_comment", property="acctComment", jdbcType=JdbcType.NVARCHAR),
        @Result(column="dr_text", property="drText", jdbcType=JdbcType.NVARCHAR),
        @Result(column="language", property="language", jdbcType=JdbcType.CHAR),
        @Result(column="res_fr_1", property="resFr1", jdbcType=JdbcType.TIMESTAMP),
        @Result(column="res_fr_2", property="resFr2", jdbcType=JdbcType.TIMESTAMP),
        @Result(column="res_to_1", property="resTo1", jdbcType=JdbcType.TIMESTAMP),
        @Result(column="res_to_2", property="resTo2", jdbcType=JdbcType.TIMESTAMP),
        @Result(column="res_live", property="resLive", jdbcType=JdbcType.CHAR),
        @Result(column="res_weekend", property="resWeekend", jdbcType=JdbcType.CHAR),
        @Result(column="res_override", property="resOverride", jdbcType=JdbcType.CHAR),
        @Result(column="share_1", property="share1", jdbcType=JdbcType.CHAR),
        @Result(column="share_2", property="share2", jdbcType=JdbcType.CHAR),
        @Result(column="gwt", property="gwt", jdbcType=JdbcType.INTEGER),
        @Result(column="stops_allowed", property="stopsAllowed", jdbcType=JdbcType.CHAR),
        @Result(column="stop_wt", property="stopWt", jdbcType=JdbcType.INTEGER),
        @Result(column="car_phone", property="carPhone", jdbcType=JdbcType.CHAR),
        @Result(column="phone_policy", property="phonePolicy", jdbcType=JdbcType.CHAR),
        @Result(column="dr_grade", property="drGrade", jdbcType=JdbcType.CHAR),
        @Result(column="smoking", property="smoking", jdbcType=JdbcType.CHAR),
        @Result(column="airport_policy", property="airportPolicy", jdbcType=JdbcType.CHAR),
        @Result(column="airport_wt_cus", property="airportWtCus", jdbcType=JdbcType.INTEGER),
        @Result(column="airport_wt_not_cus", property="airportWtNotCus", jdbcType=JdbcType.INTEGER),
        @Result(column="salesman_1", property="salesman1", jdbcType=JdbcType.CHAR),
        @Result(column="salesman_2", property="salesman2", jdbcType=JdbcType.CHAR),
        @Result(column="salesman_1_comm1", property="salesman1Comm1", jdbcType=JdbcType.DOUBLE),
        @Result(column="salesman_1_comm2", property="salesman1Comm2", jdbcType=JdbcType.INTEGER),
        @Result(column="salesman_1_comm3", property="salesman1Comm3", jdbcType=JdbcType.INTEGER),
        @Result(column="salesman_2_comm1", property="salesman2Comm1", jdbcType=JdbcType.DOUBLE),
        @Result(column="salesman_2_comm2", property="salesman2Comm2", jdbcType=JdbcType.INTEGER),
        @Result(column="salesman_2_comm3", property="salesman2Comm3", jdbcType=JdbcType.INTEGER),
        @Result(column="service_fee_A", property="serviceFeeA", jdbcType=JdbcType.DECIMAL),
        @Result(column="comp_req_1", property="compReq1", jdbcType=JdbcType.CHAR),
        @Result(column="comp_req_2", property="compReq2", jdbcType=JdbcType.CHAR),
        @Result(column="comp_req_3", property="compReq3", jdbcType=JdbcType.CHAR),
        @Result(column="comp_req_4", property="compReq4", jdbcType=JdbcType.CHAR),
        @Result(column="comp_req_5", property="compReq5", jdbcType=JdbcType.CHAR),
        @Result(column="comp_req_6", property="compReq6", jdbcType=JdbcType.CHAR),
        @Result(column="comp_len_1", property="compLen1", jdbcType=JdbcType.TINYINT),
        @Result(column="comp_len_2", property="compLen2", jdbcType=JdbcType.TINYINT),
        @Result(column="comp_len_3", property="compLen3", jdbcType=JdbcType.TINYINT),
        @Result(column="comp_len_4", property="compLen4", jdbcType=JdbcType.TINYINT),
        @Result(column="comp_len_5", property="compLen5", jdbcType=JdbcType.TINYINT),
        @Result(column="comp_len_6", property="compLen6", jdbcType=JdbcType.TINYINT),
        @Result(column="comp_pic_1", property="compPic1", jdbcType=JdbcType.CHAR),
        @Result(column="comp_pic_2", property="compPic2", jdbcType=JdbcType.CHAR),
        @Result(column="comp_pic_3", property="compPic3", jdbcType=JdbcType.CHAR),
        @Result(column="comp_pic_4", property="compPic4", jdbcType=JdbcType.CHAR),
        @Result(column="comp_pic_5", property="compPic5", jdbcType=JdbcType.CHAR),
        @Result(column="comp_pic_6", property="compPic6", jdbcType=JdbcType.CHAR),
        @Result(column="comp_ver_1", property="compVer1", jdbcType=JdbcType.CHAR),
        @Result(column="comp_ver_2", property="compVer2", jdbcType=JdbcType.CHAR),
        @Result(column="comp_ver_3", property="compVer3", jdbcType=JdbcType.CHAR),
        @Result(column="comp_ver_4", property="compVer4", jdbcType=JdbcType.CHAR),
        @Result(column="comp_ver_5", property="compVer5", jdbcType=JdbcType.CHAR),
        @Result(column="comp_ver_6", property="compVer6", jdbcType=JdbcType.CHAR),
        @Result(column="cc_no_1", property="ccNo1", jdbcType=JdbcType.CHAR),
        @Result(column="cc_no_2", property="ccNo2", jdbcType=JdbcType.CHAR),
        @Result(column="cc_exp_1", property="ccExp1", jdbcType=JdbcType.CHAR),
        @Result(column="cc_exp_2", property="ccExp2", jdbcType=JdbcType.CHAR),
        @Result(column="cc_type_1", property="ccType1", jdbcType=JdbcType.CHAR),
        @Result(column="cc_type_2", property="ccType2", jdbcType=JdbcType.CHAR),
        @Result(column="address_counter", property="addressCounter", jdbcType=JdbcType.INTEGER),
        @Result(column="company", property="company", jdbcType=JdbcType.TINYINT),
        @Result(column="VIP_by_name", property="vipByName", jdbcType=JdbcType.CHAR),
        @Result(column="req_vc", property="reqVc", jdbcType=JdbcType.CHAR),
        @Result(column="req_cc", property="reqCc", jdbcType=JdbcType.CHAR),
        @Result(column="req_vc_or_vip", property="reqVcOrVip", jdbcType=JdbcType.CHAR),
        @Result(column="issue_voucher", property="issueVoucher", jdbcType=JdbcType.CHAR),
        @Result(column="req_valid_vc_no", property="reqValidVcNo", jdbcType=JdbcType.CHAR),
        @Result(column="pricing_theory", property="pricingTheory", jdbcType=JdbcType.SMALLINT),
        @Result(column="grace_wt", property="graceWt", jdbcType=JdbcType.INTEGER),
        @Result(column="comp_len_1_min", property="compLen1Min", jdbcType=JdbcType.TINYINT),
        @Result(column="comp_len_2_min", property="compLen2Min", jdbcType=JdbcType.TINYINT),
        @Result(column="comp_len_3_min", property="compLen3Min", jdbcType=JdbcType.TINYINT),
        @Result(column="comp_len_4_min", property="compLen4Min", jdbcType=JdbcType.TINYINT),
        @Result(column="comp_len_5_min", property="compLen5Min", jdbcType=JdbcType.TINYINT),
        @Result(column="comp_len_6_min", property="compLen6Min", jdbcType=JdbcType.TINYINT),
        @Result(column="Req_Sub_Acct_ID", property="reqSubAcctId", jdbcType=JdbcType.CHAR),
        @Result(column="Discount_Perc", property="discountPerc", jdbcType=JdbcType.DECIMAL),
        @Result(column="Free_Minutes", property="freeMinutes", jdbcType=JdbcType.SMALLINT),
        @Result(column="PhoneCharge_PerMin", property="phonechargePermin", jdbcType=JdbcType.DECIMAL),
        @Result(column="Cash_Account", property="cashAccount", jdbcType=JdbcType.CHAR),
        @Result(column="billing_cycle_days", property="billingCycleDays", jdbcType=JdbcType.TINYINT),
        @Result(column="Discount_Type", property="discountType", jdbcType=JdbcType.TINYINT),
        @Result(column="PhnCharge_PerMin_Local", property="phnchargePerminLocal", jdbcType=JdbcType.DECIMAL),
        @Result(column="PhnCharge_PerMin_LongD", property="phnchargePerminLongd", jdbcType=JdbcType.DECIMAL),
        @Result(column="PhnCharge_PerMin_Intl", property="phnchargePerminIntl", jdbcType=JdbcType.DECIMAL),
        @Result(column="CompReq1_Display", property="compreq1Display", jdbcType=JdbcType.CHAR),
        @Result(column="CompReq2_Display", property="compreq2Display", jdbcType=JdbcType.CHAR),
        @Result(column="CompReq3_Display", property="compreq3Display", jdbcType=JdbcType.CHAR),
        @Result(column="CompReq4_Display", property="compreq4Display", jdbcType=JdbcType.CHAR),
        @Result(column="CompReq5_Display", property="compreq5Display", jdbcType=JdbcType.CHAR),
        @Result(column="CompReq6_Display", property="compreq6Display", jdbcType=JdbcType.CHAR),
        @Result(column="st_no", property="stNo", jdbcType=JdbcType.VARCHAR),
        @Result(column="Service_Fee_B", property="serviceFeeB", jdbcType=JdbcType.DECIMAL),
        @Result(column="service_fee_prt_fmt", property="serviceFeePrtFmt", jdbcType=JdbcType.TINYINT),
        @Result(column="Grace_Stop_WT", property="graceStopWt", jdbcType=JdbcType.SMALLINT),
        @Result(column="WT_Charge_Per_Hr", property="wtChargePerHr", jdbcType=JdbcType.DECIMAL),
        @Result(column="Stop_WT_Charge_Per_Hr", property="stopWtChargePerHr", jdbcType=JdbcType.DECIMAL),
        @Result(column="StopOpenIfNon0Fare", property="stopopenifnon0fare", jdbcType=JdbcType.CHAR),
        @Result(column="DisableStopAutoOpen", property="disablestopautoopen", jdbcType=JdbcType.CHAR),
        @Result(column="tip_perc", property="tipPerc", jdbcType=JdbcType.TINYINT),
        @Result(column="Display_Service_Fee", property="displayServiceFee", jdbcType=JdbcType.CHAR),
        @Result(column="call_back", property="callBack", jdbcType=JdbcType.CHAR),
        @Result(column="InterNet", property="internet", jdbcType=JdbcType.CHAR),
        @Result(column="vip_label", property="vipLabel", jdbcType=JdbcType.VARCHAR),
        @Result(column="vip_label_ver", property="vipLabelVer", jdbcType=JdbcType.CHAR),
        @Result(column="verify_cc", property="verifyCc", jdbcType=JdbcType.CHAR),
        @Result(column="auth_pers_req", property="authPersReq", jdbcType=JdbcType.CHAR),
        @Result(column="service_percentage", property="servicePercentage", jdbcType=JdbcType.DECIMAL),
        @Result(column="Tax_exempt", property="taxExempt", jdbcType=JdbcType.BIT),
        @Result(column="Print_SubAddress", property="printSubaddress", jdbcType=JdbcType.CHAR),
        @Result(column="Print_DiffInvNo", property="printDiffinvno", jdbcType=JdbcType.CHAR),
        @Result(column="vehicle_grade", property="vehicleGrade", jdbcType=JdbcType.CHAR),
        @Result(column="Apply_Surcharge", property="applySurcharge", jdbcType=JdbcType.CHAR),
        @Result(column="payment_type", property="paymentType", jdbcType=JdbcType.CHAR),
        @Result(column="salesman1_comm1", property="salesman1Comm1", jdbcType=JdbcType.DECIMAL),
        @Result(column="salesman2_comm2", property="salesman2Comm2", jdbcType=JdbcType.DECIMAL),
        @Result(column="salesman3_comm3", property="salesman3Comm3", jdbcType=JdbcType.DECIMAL),
        @Result(column="salesman4_comm4", property="salesman4Comm4", jdbcType=JdbcType.DECIMAL),
        @Result(column="Meet_Greet", property="meetGreet", jdbcType=JdbcType.DECIMAL),
        @Result(column="package", property="package", jdbcType=JdbcType.DECIMAL),
        @Result(column="Reservation", property="reservation", jdbcType=JdbcType.DECIMAL),
        @Result(column="Reservation_OT", property="reservationOt", jdbcType=JdbcType.DECIMAL),
        @Result(column="grace_resey_wt", property="graceReseyWt", jdbcType=JdbcType.SMALLINT),
        @Result(column="resey_WT_Charge_Per_Hr", property="reseyWtChargePerHr", jdbcType=JdbcType.DECIMAL),
        @Result(column="year_greater_than", property="yearGreaterThan", jdbcType=JdbcType.CHAR),
        @Result(column="greater_than", property="greaterThan", jdbcType=JdbcType.SMALLINT),
        @Result(column="business_class", property="businessClass", jdbcType=JdbcType.CHAR),
        @Result(column="salesman1_comm2", property="salesman1Comm2", jdbcType=JdbcType.DECIMAL),
        @Result(column="salesman2_comm1", property="salesman2Comm1", jdbcType=JdbcType.DECIMAL),
        @Result(column="deductible_amt", property="deductibleAmt", jdbcType=JdbcType.DECIMAL),
        @Result(column="email_address", property="emailAddress", jdbcType=JdbcType.VARCHAR),
        @Result(column="email_notification", property="emailNotification", jdbcType=JdbcType.CHAR),
        @Result(column="last_date", property="lastDate", jdbcType=JdbcType.TIMESTAMP),
        @Result(column="acct_id_to_reffer", property="acctIdToReffer", jdbcType=JdbcType.CHAR),
        @Result(column="OT_surcharge_amt", property="otSurchargeAmt", jdbcType=JdbcType.DECIMAL),
        @Result(column="meet_greet_amt", property="meetGreetAmt", jdbcType=JdbcType.DECIMAL),
        @Result(column="Display_OT_surcharge", property="displayOtSurcharge", jdbcType=JdbcType.CHAR),
        @Result(column="Display_M_G_Amt", property="displayMGAmt", jdbcType=JdbcType.CHAR),
        @Result(column="vch_per_page", property="vchPerPage", jdbcType=JdbcType.TINYINT),
        @Result(column="auth_pers_validate", property="authPersValidate", jdbcType=JdbcType.CHAR),
        @Result(column="st_no_nong", property="stNoNong", jdbcType=JdbcType.CHAR),
        @Result(column="user_name", property="userName", jdbcType=JdbcType.VARCHAR),
        @Result(column="active_flag", property="activeFlag", jdbcType=JdbcType.CHAR),
        @Result(column="active_date", property="activeDate", jdbcType=JdbcType.TIMESTAMP),
        @Result(column="contect_name", property="contectName", jdbcType=JdbcType.VARCHAR),
        @Result(column="invoice_name", property="invoiceName", jdbcType=JdbcType.VARCHAR),
        @Result(column="landmark", property="landmark", jdbcType=JdbcType.CHAR),
        @Result(column="fapiao", property="fapiao", jdbcType=JdbcType.CHAR),
        @Result(column="advance_info", property="advanceInfo", jdbcType=JdbcType.CHAR),
        @Result(column="vip_flag", property="vipFlag", jdbcType=JdbcType.CHAR),
        @Result(column="vip2_flag", property="vip2Flag", jdbcType=JdbcType.CHAR),
        @Result(column="manager", property="manager", jdbcType=JdbcType.CHAR),
        @Result(column="manager_comm", property="managerComm", jdbcType=JdbcType.DOUBLE),
        @Result(column="opr", property="opr", jdbcType=JdbcType.CHAR),
        @Result(column="opr_comm", property="oprComm", jdbcType=JdbcType.DOUBLE),
        @Result(column="advance_remind", property="advanceRemind", jdbcType=JdbcType.CHAR),
        @Result(column="maintenance_man", property="maintenanceMan", jdbcType=JdbcType.VARCHAR),
        @Result(column="maintenance_status", property="maintenanceStatus", jdbcType=JdbcType.CHAR),
        @Result(column="maintenance_date_time", property="maintenanceDateTime", jdbcType=JdbcType.TIMESTAMP),
        @Result(column="maintenance_deep", property="maintenanceDeep", jdbcType=JdbcType.CHAR),
        @Result(column="pay_comment", property="payComment", jdbcType=JdbcType.NVARCHAR),
        @Result(column="register_comment", property="registerComment", jdbcType=JdbcType.NVARCHAR),
        @Result(column="self_privilege", property="selfPrivilege", jdbcType=JdbcType.CHAR),
        @Result(column="self_order_mailcc", property="selfOrderMailcc", jdbcType=JdbcType.VARCHAR),
        @Result(column="self_order_guarantee", property="selfOrderGuarantee", jdbcType=JdbcType.CHAR),
        @Result(column="confirm_flag", property="confirmFlag", jdbcType=JdbcType.CHAR),
        @Result(column="rebate_percent", property="rebatePercent", jdbcType=JdbcType.SMALLINT),
        @Result(column="rebate_amount", property="rebateAmount", jdbcType=JdbcType.DECIMAL),
        @Result(column="card_level", property="cardLevel", jdbcType=JdbcType.SMALLINT),
        @Result(column="self_discount", property="selfDiscount", jdbcType=JdbcType.SMALLINT),
        @Result(column="acct_sms_order", property="acctSmsOrder", jdbcType=JdbcType.CHAR),
        @Result(column="need_price", property="needPrice", jdbcType=JdbcType.CHAR),
        @Result(column="need_sms", property="needSms", jdbcType=JdbcType.CHAR),
        @Result(column="need_email", property="needEmail", jdbcType=JdbcType.CHAR),
        @Result(column="english_customer", property="englishCustomer", jdbcType=JdbcType.CHAR),
        @Result(column="CarType_plus", property="cartypePlus", jdbcType=JdbcType.CHAR),
        @Result(column="insurance_assure", property="insuranceAssure", jdbcType=JdbcType.CHAR),
        @Result(column="guarantee_assure", property="guaranteeAssure", jdbcType=JdbcType.CHAR),
        @Result(column="service_comment", property="serviceComment", jdbcType=JdbcType.VARCHAR),
        @Result(column="aff_fapiao", property="affFapiao", jdbcType=JdbcType.CHAR),
        @Result(column="AttnName", property="attnname", jdbcType=JdbcType.VARCHAR),
        @Result(column="AttnPhoneExt", property="attnphoneext", jdbcType=JdbcType.VARCHAR),
        @Result(column="AttnPhone", property="attnphone", jdbcType=JdbcType.VARCHAR),
        @Result(column="AttnMobile", property="attnmobile", jdbcType=JdbcType.VARCHAR),
        @Result(column="AttnEmail", property="attnemail", jdbcType=JdbcType.VARCHAR),
        @Result(column="DeciName", property="deciname", jdbcType=JdbcType.VARCHAR),
        @Result(column="DeciPhoneExt", property="deciphoneext", jdbcType=JdbcType.VARCHAR),
        @Result(column="DeciPhone", property="deciphone", jdbcType=JdbcType.VARCHAR),
        @Result(column="DeciMobile", property="decimobile", jdbcType=JdbcType.VARCHAR),
        @Result(column="DeciEmail", property="deciemail", jdbcType=JdbcType.VARCHAR),
        @Result(column="email4", property="email4", jdbcType=JdbcType.VARCHAR),
        @Result(column="email3", property="email3", jdbcType=JdbcType.VARCHAR),
        @Result(column="BillingPeriod", property="billingperiod", jdbcType=JdbcType.VARCHAR),
        @Result(column="FinanceName", property="financename", jdbcType=JdbcType.VARCHAR),
        @Result(column="FinancePhone", property="financephone", jdbcType=JdbcType.VARCHAR),
        @Result(column="IndustryClass", property="industryclass", jdbcType=JdbcType.INTEGER),
        @Result(column="BusinessProperty", property="businessproperty", jdbcType=JdbcType.INTEGER),
        @Result(column="PriceType", property="pricetype", jdbcType=JdbcType.INTEGER),
        @Result(column="parentId", property="parentid", jdbcType=JdbcType.VARCHAR),
        @Result(column="Book_state", property="bookState", jdbcType=JdbcType.VARCHAR),
        @Result(column="Book_city", property="bookCity", jdbcType=JdbcType.VARCHAR),
        @Result(column="Book_st_name", property="bookStName", jdbcType=JdbcType.VARCHAR),
        @Result(column="Book_st_no_nong", property="bookStNoNong", jdbcType=JdbcType.VARCHAR),
        @Result(column="Book_st_no", property="bookStNo", jdbcType=JdbcType.VARCHAR),
        @Result(column="Book_landmark", property="bookLandmark", jdbcType=JdbcType.VARCHAR),
        @Result(column="Book_Apt", property="bookApt", jdbcType=JdbcType.VARCHAR),
        @Result(column="ClearingRemarks", property="clearingremarks", jdbcType=JdbcType.VARCHAR),
        @Result(column="FinancialNotes", property="financialnotes", jdbcType=JdbcType.VARCHAR),
        @Result(column="BillRec_state", property="billrecState", jdbcType=JdbcType.VARCHAR),
        @Result(column="BillRec_city", property="billrecCity", jdbcType=JdbcType.VARCHAR),
        @Result(column="BillRec_st_name", property="billrecStName", jdbcType=JdbcType.VARCHAR),
        @Result(column="BillRec_st_no_nong", property="billrecStNoNong", jdbcType=JdbcType.VARCHAR),
        @Result(column="BillRec_st_no", property="billrecStNo", jdbcType=JdbcType.VARCHAR),
        @Result(column="BillRec_landmark", property="billrecLandmark", jdbcType=JdbcType.VARCHAR),
        @Result(column="BillRec_Apt", property="billrecApt", jdbcType=JdbcType.VARCHAR),
        @Result(column="BillPa_state", property="billpaState", jdbcType=JdbcType.VARCHAR),
        @Result(column="BillPa_city", property="billpaCity", jdbcType=JdbcType.VARCHAR),
        @Result(column="BillPa_st_name", property="billpaStName", jdbcType=JdbcType.VARCHAR),
        @Result(column="BillPa_st_no_nong", property="billpaStNoNong", jdbcType=JdbcType.VARCHAR),
        @Result(column="BillPa_st_no", property="billpaStNo", jdbcType=JdbcType.VARCHAR),
        @Result(column="BillPa_landmark", property="billpaLandmark", jdbcType=JdbcType.VARCHAR),
        @Result(column="BillPa_Apt", property="billpaApt", jdbcType=JdbcType.VARCHAR),
        @Result(column="fapiao_divide", property="fapiaoDivide", jdbcType=JdbcType.CHAR),
        @Result(column="achievement_include", property="achievementInclude", jdbcType=JdbcType.CHAR),
        @Result(column="settlement", property="settlement", jdbcType=JdbcType.VARCHAR),
        @Result(column="credit_rating", property="creditRating", jdbcType=JdbcType.INTEGER),
        @Result(column="VerificationCycle", property="verificationcycle", jdbcType=JdbcType.VARCHAR),
        @Result(column="fuelSurcharge", property="fuelsurcharge", jdbcType=JdbcType.NCHAR),
        @Result(column="fapiao_type", property="fapiaoType", jdbcType=JdbcType.CHAR),
        @Result(column="VIN_zzs", property="vinZzs", jdbcType=JdbcType.VARCHAR),
        @Result(column="addr_zzs", property="addrZzs", jdbcType=JdbcType.VARCHAR),
        @Result(column="phone_zzs", property="phoneZzs", jdbcType=JdbcType.VARCHAR),
        @Result(column="bank_zzs", property="bankZzs", jdbcType=JdbcType.VARCHAR),
        @Result(column="bankno_zzs", property="banknoZzs", jdbcType=JdbcType.VARCHAR),
        @Result(column="tax_percent", property="taxPercent", jdbcType=JdbcType.DECIMAL),
        @Result(column="login_flag", property="loginFlag", jdbcType=JdbcType.CHAR),
        @Result(column="self_settlement", property="selfSettlement", jdbcType=JdbcType.CHAR),
        @Result(column="acct_city", property="acctCity", jdbcType=JdbcType.VARCHAR),
        @Result(column="regprice", property="regprice", jdbcType=JdbcType.INTEGER),
        @Result(column="MeetGreet", property="meetgreet", jdbcType=JdbcType.CHAR),
        @Result(column="inner_car_flag", property="innerCarFlag", jdbcType=JdbcType.CHAR),
        @Result(column="IsPoBill", property="ispobill", jdbcType=JdbcType.BIT),
        @Result(column="SalesmanBlock", property="salesmanblock", jdbcType=JdbcType.INTEGER),
        @Result(column="SettlementBlock", property="settlementblock", jdbcType=JdbcType.VARCHAR),
        @Result(column="IsElectronicInvoice", property="iselectronicinvoice", jdbcType=JdbcType.BIT),
        @Result(column="ServiceType", property="servicetype", jdbcType=JdbcType.TINYINT),
        @Result(column="IsNoDispatch", property="isnodispatch", jdbcType=JdbcType.BIT)
    })
    List<Account> selectMany(SelectStatementProvider selectStatement);

    @Generated("org.mybatis.generator.api.MyBatisGenerator")
    @UpdateProvider(type=SqlProviderAdapter.class, method="update")
    int update(UpdateStatementProvider updateStatement);

    @Generated("org.mybatis.generator.api.MyBatisGenerator")
    default QueryExpressionDSL<MyBatis3SelectModelAdapter<Long>> countByExample() {
        return SelectDSL.selectWithMapper(this::count, SqlBuilder.count())
                .from(account);
    }

    @Generated("org.mybatis.generator.api.MyBatisGenerator")
    default DeleteDSL<MyBatis3DeleteModelAdapter<Integer>> deleteByExample() {
        return DeleteDSL.deleteFromWithMapper(this::delete, account);
    }

    @Generated("org.mybatis.generator.api.MyBatisGenerator")
    default int deleteByPrimaryKey(String acctId_) {
        return DeleteDSL.deleteFromWithMapper(this::delete, account)
                .where(acctId, isEqualTo(acctId_))
                .build()
                .execute();
    }

    @Generated("org.mybatis.generator.api.MyBatisGenerator")
    default int insert(Account record) {
        return insert(SqlBuilder.insert(record)
                .into(account)
                .map(acctId).toProperty("acctId")
                .map(subAcctId).toProperty("subAcctId")
                .map(name).toProperty("name")
                .map(tempStNo).toProperty("tempStNo")
                .map(stName).toProperty("stName")
                .map(suite).toProperty("suite")
                .map(city).toProperty("city")
                .map(state).toProperty("state")
                .map(zip).toProperty("zip")
                .map(subZip).toProperty("subZip")
                .map(attention1).toProperty("attention1")
                .map(attention2).toProperty("attention2")
                .map(attention3).toProperty("attention3")
                .map(attention4).toProperty("attention4")
                .map(phone1).toProperty("phone1")
                .map(phone2).toProperty("phone2")
                .map(phone3).toProperty("phone3")
                .map(phone4).toProperty("phone4")
                .map(ext1).toProperty("ext1")
                .map(ext2).toProperty("ext2")
                .map(ext3).toProperty("ext3")
                .map(ext4).toProperty("ext4")
                .map(fax).toProperty("fax")
                .map(wwwAddress).toProperty("wwwAddress")
                .map(dataLine).toProperty("dataLine")
                .map(logOn).toProperty("logOn")
                .map(password).toProperty("password")
                .map(priority).toProperty("priority")
                .map(pmtCode).toProperty("pmtCode")
                .map(pmtTerm).toProperty("pmtTerm")
                .map(creditLimit).toProperty("creditLimit")
                .map(billingCycle).toProperty("billingCycle")
                .map(creditStatus).toProperty("creditStatus")
                .map(openDate).toProperty("openDate")
                .map(openComment).toProperty("openComment")
                .map(closeDate).toProperty("closeDate")
                .map(closeComment).toProperty("closeComment")
                .map(tableId).toProperty("tableId")
                .map(acctComment).toProperty("acctComment")
                .map(drText).toProperty("drText")
                .map(language).toProperty("language")
                .map(resFr1).toProperty("resFr1")
                .map(resFr2).toProperty("resFr2")
                .map(resTo1).toProperty("resTo1")
                .map(resTo2).toProperty("resTo2")
                .map(resLive).toProperty("resLive")
                .map(resWeekend).toProperty("resWeekend")
                .map(resOverride).toProperty("resOverride")
                .map(share1).toProperty("share1")
                .map(share2).toProperty("share2")
                .map(gwt).toProperty("gwt")
                .map(stopsAllowed).toProperty("stopsAllowed")
                .map(stopWt).toProperty("stopWt")
                .map(carPhone).toProperty("carPhone")
                .map(phonePolicy).toProperty("phonePolicy")
                .map(drGrade).toProperty("drGrade")
                .map(smoking).toProperty("smoking")
                .map(airportPolicy).toProperty("airportPolicy")
                .map(airportWtCus).toProperty("airportWtCus")
                .map(airportWtNotCus).toProperty("airportWtNotCus")
                .map(salesman1).toProperty("salesman1")
                .map(salesman2).toProperty("salesman2")
                .map(salesman1Comm1).toProperty("salesman1Comm1")
                .map(salesman1Comm2).toProperty("salesman1Comm2")
                .map(salesman1Comm3).toProperty("salesman1Comm3")
                .map(salesman2Comm1).toProperty("salesman2Comm1")
                .map(salesman2Comm2).toProperty("salesman2Comm2")
                .map(salesman2Comm3).toProperty("salesman2Comm3")
                .map(serviceFeeA).toProperty("serviceFeeA")
                .map(compReq1).toProperty("compReq1")
                .map(compReq2).toProperty("compReq2")
                .map(compReq3).toProperty("compReq3")
                .map(compReq4).toProperty("compReq4")
                .map(compReq5).toProperty("compReq5")
                .map(compReq6).toProperty("compReq6")
                .map(compLen1).toProperty("compLen1")
                .map(compLen2).toProperty("compLen2")
                .map(compLen3).toProperty("compLen3")
                .map(compLen4).toProperty("compLen4")
                .map(compLen5).toProperty("compLen5")
                .map(compLen6).toProperty("compLen6")
                .map(compPic1).toProperty("compPic1")
                .map(compPic2).toProperty("compPic2")
                .map(compPic3).toProperty("compPic3")
                .map(compPic4).toProperty("compPic4")
                .map(compPic5).toProperty("compPic5")
                .map(compPic6).toProperty("compPic6")
                .map(compVer1).toProperty("compVer1")
                .map(compVer2).toProperty("compVer2")
                .map(compVer3).toProperty("compVer3")
                .map(compVer4).toProperty("compVer4")
                .map(compVer5).toProperty("compVer5")
                .map(compVer6).toProperty("compVer6")
                .map(ccNo1).toProperty("ccNo1")
                .map(ccNo2).toProperty("ccNo2")
                .map(ccExp1).toProperty("ccExp1")
                .map(ccExp2).toProperty("ccExp2")
                .map(ccType1).toProperty("ccType1")
                .map(ccType2).toProperty("ccType2")
                .map(addressCounter).toProperty("addressCounter")
                .map(company).toProperty("company")
                .map(vipByName).toProperty("vipByName")
                .map(reqVc).toProperty("reqVc")
                .map(reqCc).toProperty("reqCc")
                .map(reqVcOrVip).toProperty("reqVcOrVip")
                .map(issueVoucher).toProperty("issueVoucher")
                .map(reqValidVcNo).toProperty("reqValidVcNo")
                .map(pricingTheory).toProperty("pricingTheory")
                .map(graceWt).toProperty("graceWt")
                .map(compLen1Min).toProperty("compLen1Min")
                .map(compLen2Min).toProperty("compLen2Min")
                .map(compLen3Min).toProperty("compLen3Min")
                .map(compLen4Min).toProperty("compLen4Min")
                .map(compLen5Min).toProperty("compLen5Min")
                .map(compLen6Min).toProperty("compLen6Min")
                .map(reqSubAcctId).toProperty("reqSubAcctId")
                .map(discountPerc).toProperty("discountPerc")
                .map(freeMinutes).toProperty("freeMinutes")
                .map(phonechargePermin).toProperty("phonechargePermin")
                .map(cashAccount).toProperty("cashAccount")
                .map(billingCycleDays).toProperty("billingCycleDays")
                .map(discountType).toProperty("discountType")
                .map(phnchargePerminLocal).toProperty("phnchargePerminLocal")
                .map(phnchargePerminLongd).toProperty("phnchargePerminLongd")
                .map(phnchargePerminIntl).toProperty("phnchargePerminIntl")
                .map(compreq1Display).toProperty("compreq1Display")
                .map(compreq2Display).toProperty("compreq2Display")
                .map(compreq3Display).toProperty("compreq3Display")
                .map(compreq4Display).toProperty("compreq4Display")
                .map(compreq5Display).toProperty("compreq5Display")
                .map(compreq6Display).toProperty("compreq6Display")
                .map(stNo).toProperty("stNo")
                .map(serviceFeeB).toProperty("serviceFeeB")
                .map(serviceFeePrtFmt).toProperty("serviceFeePrtFmt")
                .map(graceStopWt).toProperty("graceStopWt")
                .map(wtChargePerHr).toProperty("wtChargePerHr")
                .map(stopWtChargePerHr).toProperty("stopWtChargePerHr")
                .map(stopopenifnon0fare).toProperty("stopopenifnon0fare")
                .map(disablestopautoopen).toProperty("disablestopautoopen")
                .map(tipPerc).toProperty("tipPerc")
                .map(displayServiceFee).toProperty("displayServiceFee")
                .map(callBack).toProperty("callBack")
                .map(internet).toProperty("internet")
                .map(vipLabel).toProperty("vipLabel")
                .map(vipLabelVer).toProperty("vipLabelVer")
                .map(verifyCc).toProperty("verifyCc")
                .map(authPersReq).toProperty("authPersReq")
                .map(servicePercentage).toProperty("servicePercentage")
                .map(taxExempt).toProperty("taxExempt")
                .map(printSubaddress).toProperty("printSubaddress")
                .map(printDiffinvno).toProperty("printDiffinvno")
                .map(vehicleGrade).toProperty("vehicleGrade")
                .map(applySurcharge).toProperty("applySurcharge")
                .map(paymentType).toProperty("paymentType")
                .map(salesman1Comm1).toProperty("salesman1Comm1")
                .map(salesman2Comm2).toProperty("salesman2Comm2")
                .map(salesman3Comm3).toProperty("salesman3Comm3")
                .map(salesman4Comm4).toProperty("salesman4Comm4")
                .map(meetGreet).toProperty("meetGreet")
                .map(packagex).toProperty("package")
                .map(reservation).toProperty("reservation")
                .map(reservationOt).toProperty("reservationOt")
                .map(graceReseyWt).toProperty("graceReseyWt")
                .map(reseyWtChargePerHr).toProperty("reseyWtChargePerHr")
                .map(yearGreaterThan).toProperty("yearGreaterThan")
                .map(greaterThan).toProperty("greaterThan")
                .map(businessClass).toProperty("businessClass")
                .map(salesman1Comm2).toProperty("salesman1Comm2")
                .map(salesman2Comm1).toProperty("salesman2Comm1")
                .map(deductibleAmt).toProperty("deductibleAmt")
                .map(emailAddress).toProperty("emailAddress")
                .map(emailNotification).toProperty("emailNotification")
                .map(lastDate).toProperty("lastDate")
                .map(acctIdToReffer).toProperty("acctIdToReffer")
                .map(otSurchargeAmt).toProperty("otSurchargeAmt")
                .map(meetGreetAmt).toProperty("meetGreetAmt")
                .map(displayOtSurcharge).toProperty("displayOtSurcharge")
                .map(displayMGAmt).toProperty("displayMGAmt")
                .map(vchPerPage).toProperty("vchPerPage")
                .map(authPersValidate).toProperty("authPersValidate")
                .map(stNoNong).toProperty("stNoNong")
                .map(userName).toProperty("userName")
                .map(activeFlag).toProperty("activeFlag")
                .map(activeDate).toProperty("activeDate")
                .map(contectName).toProperty("contectName")
                .map(invoiceName).toProperty("invoiceName")
                .map(landmark).toProperty("landmark")
                .map(fapiao).toProperty("fapiao")
                .map(advanceInfo).toProperty("advanceInfo")
                .map(vipFlag).toProperty("vipFlag")
                .map(vip2Flag).toProperty("vip2Flag")
                .map(manager).toProperty("manager")
                .map(managerComm).toProperty("managerComm")
                .map(opr).toProperty("opr")
                .map(oprComm).toProperty("oprComm")
                .map(advanceRemind).toProperty("advanceRemind")
                .map(maintenanceMan).toProperty("maintenanceMan")
                .map(maintenanceStatus).toProperty("maintenanceStatus")
                .map(maintenanceDateTime).toProperty("maintenanceDateTime")
                .map(maintenanceDeep).toProperty("maintenanceDeep")
                .map(payComment).toProperty("payComment")
                .map(registerComment).toProperty("registerComment")
                .map(selfPrivilege).toProperty("selfPrivilege")
                .map(selfOrderMailcc).toProperty("selfOrderMailcc")
                .map(selfOrderGuarantee).toProperty("selfOrderGuarantee")
                .map(confirmFlag).toProperty("confirmFlag")
                .map(rebatePercent).toProperty("rebatePercent")
                .map(rebateAmount).toProperty("rebateAmount")
                .map(cardLevel).toProperty("cardLevel")
                .map(selfDiscount).toProperty("selfDiscount")
                .map(acctSmsOrder).toProperty("acctSmsOrder")
                .map(needPrice).toProperty("needPrice")
                .map(needSms).toProperty("needSms")
                .map(needEmail).toProperty("needEmail")
                .map(englishCustomer).toProperty("englishCustomer")
                .map(cartypePlus).toProperty("cartypePlus")
                .map(insuranceAssure).toProperty("insuranceAssure")
                .map(guaranteeAssure).toProperty("guaranteeAssure")
                .map(serviceComment).toProperty("serviceComment")
                .map(affFapiao).toProperty("affFapiao")
                .map(attnname).toProperty("attnname")
                .map(attnphoneext).toProperty("attnphoneext")
                .map(attnphone).toProperty("attnphone")
                .map(attnmobile).toProperty("attnmobile")
                .map(attnemail).toProperty("attnemail")
                .map(deciname).toProperty("deciname")
                .map(deciphoneext).toProperty("deciphoneext")
                .map(deciphone).toProperty("deciphone")
                .map(decimobile).toProperty("decimobile")
                .map(deciemail).toProperty("deciemail")
                .map(email4).toProperty("email4")
                .map(email3).toProperty("email3")
                .map(billingperiod).toProperty("billingperiod")
                .map(financename).toProperty("financename")
                .map(financephone).toProperty("financephone")
                .map(industryclass).toProperty("industryclass")
                .map(businessproperty).toProperty("businessproperty")
                .map(pricetype).toProperty("pricetype")
                .map(parentid).toProperty("parentid")
                .map(bookState).toProperty("bookState")
                .map(bookCity).toProperty("bookCity")
                .map(bookStName).toProperty("bookStName")
                .map(bookStNoNong).toProperty("bookStNoNong")
                .map(bookStNo).toProperty("bookStNo")
                .map(bookLandmark).toProperty("bookLandmark")
                .map(bookApt).toProperty("bookApt")
                .map(clearingremarks).toProperty("clearingremarks")
                .map(financialnotes).toProperty("financialnotes")
                .map(billrecState).toProperty("billrecState")
                .map(billrecCity).toProperty("billrecCity")
                .map(billrecStName).toProperty("billrecStName")
                .map(billrecStNoNong).toProperty("billrecStNoNong")
                .map(billrecStNo).toProperty("billrecStNo")
                .map(billrecLandmark).toProperty("billrecLandmark")
                .map(billrecApt).toProperty("billrecApt")
                .map(billpaState).toProperty("billpaState")
                .map(billpaCity).toProperty("billpaCity")
                .map(billpaStName).toProperty("billpaStName")
                .map(billpaStNoNong).toProperty("billpaStNoNong")
                .map(billpaStNo).toProperty("billpaStNo")
                .map(billpaLandmark).toProperty("billpaLandmark")
                .map(billpaApt).toProperty("billpaApt")
                .map(fapiaoDivide).toProperty("fapiaoDivide")
                .map(achievementInclude).toProperty("achievementInclude")
                .map(settlement).toProperty("settlement")
                .map(creditRating).toProperty("creditRating")
                .map(verificationcycle).toProperty("verificationcycle")
                .map(fuelsurcharge).toProperty("fuelsurcharge")
                .map(fapiaoType).toProperty("fapiaoType")
                .map(vinZzs).toProperty("vinZzs")
                .map(addrZzs).toProperty("addrZzs")
                .map(phoneZzs).toProperty("phoneZzs")
                .map(bankZzs).toProperty("bankZzs")
                .map(banknoZzs).toProperty("banknoZzs")
                .map(taxPercent).toProperty("taxPercent")
                .map(loginFlag).toProperty("loginFlag")
                .map(selfSettlement).toProperty("selfSettlement")
                .map(acctCity).toProperty("acctCity")
                .map(regprice).toProperty("regprice")
                .map(meetgreet).toProperty("meetgreet")
                .map(innerCarFlag).toProperty("innerCarFlag")
                .map(ispobill).toProperty("ispobill")
                .map(salesmanblock).toProperty("salesmanblock")
                .map(settlementblock).toProperty("settlementblock")
                .map(iselectronicinvoice).toProperty("iselectronicinvoice")
                .map(servicetype).toProperty("servicetype")
                .map(isnodispatch).toProperty("isnodispatch")
                .build()
                .render(RenderingStrategy.MYBATIS3));
    }

    @Generated("org.mybatis.generator.api.MyBatisGenerator")
    default int insertSelective(Account record) {
        return insert(SqlBuilder.insert(record)
                .into(account)
                .map(acctId).toPropertyWhenPresent("acctId", record::getAcctId)
                .map(subAcctId).toPropertyWhenPresent("subAcctId", record::getSubAcctId)
                .map(name).toPropertyWhenPresent("name", record::getName)
                .map(tempStNo).toPropertyWhenPresent("tempStNo", record::getTempStNo)
                .map(stName).toPropertyWhenPresent("stName", record::getStName)
                .map(suite).toPropertyWhenPresent("suite", record::getSuite)
                .map(city).toPropertyWhenPresent("city", record::getCity)
                .map(state).toPropertyWhenPresent("state", record::getState)
                .map(zip).toPropertyWhenPresent("zip", record::getZip)
                .map(subZip).toPropertyWhenPresent("subZip", record::getSubZip)
                .map(attention1).toPropertyWhenPresent("attention1", record::getAttention1)
                .map(attention2).toPropertyWhenPresent("attention2", record::getAttention2)
                .map(attention3).toPropertyWhenPresent("attention3", record::getAttention3)
                .map(attention4).toPropertyWhenPresent("attention4", record::getAttention4)
                .map(phone1).toPropertyWhenPresent("phone1", record::getPhone1)
                .map(phone2).toPropertyWhenPresent("phone2", record::getPhone2)
                .map(phone3).toPropertyWhenPresent("phone3", record::getPhone3)
                .map(phone4).toPropertyWhenPresent("phone4", record::getPhone4)
                .map(ext1).toPropertyWhenPresent("ext1", record::getExt1)
                .map(ext2).toPropertyWhenPresent("ext2", record::getExt2)
                .map(ext3).toPropertyWhenPresent("ext3", record::getExt3)
                .map(ext4).toPropertyWhenPresent("ext4", record::getExt4)
                .map(fax).toPropertyWhenPresent("fax", record::getFax)
                .map(wwwAddress).toPropertyWhenPresent("wwwAddress", record::getWwwAddress)
                .map(dataLine).toPropertyWhenPresent("dataLine", record::getDataLine)
                .map(logOn).toPropertyWhenPresent("logOn", record::getLogOn)
                .map(password).toPropertyWhenPresent("password", record::getPassword)
                .map(priority).toPropertyWhenPresent("priority", record::getPriority)
                .map(pmtCode).toPropertyWhenPresent("pmtCode", record::getPmtCode)
                .map(pmtTerm).toPropertyWhenPresent("pmtTerm", record::getPmtTerm)
                .map(creditLimit).toPropertyWhenPresent("creditLimit", record::getCreditLimit)
                .map(billingCycle).toPropertyWhenPresent("billingCycle", record::getBillingCycle)
                .map(creditStatus).toPropertyWhenPresent("creditStatus", record::getCreditStatus)
                .map(openDate).toPropertyWhenPresent("openDate", record::getOpenDate)
                .map(openComment).toPropertyWhenPresent("openComment", record::getOpenComment)
                .map(closeDate).toPropertyWhenPresent("closeDate", record::getCloseDate)
                .map(closeComment).toPropertyWhenPresent("closeComment", record::getCloseComment)
                .map(tableId).toPropertyWhenPresent("tableId", record::getTableId)
                .map(acctComment).toPropertyWhenPresent("acctComment", record::getAcctComment)
                .map(drText).toPropertyWhenPresent("drText", record::getDrText)
                .map(language).toPropertyWhenPresent("language", record::getLanguage)
                .map(resFr1).toPropertyWhenPresent("resFr1", record::getResFr1)
                .map(resFr2).toPropertyWhenPresent("resFr2", record::getResFr2)
                .map(resTo1).toPropertyWhenPresent("resTo1", record::getResTo1)
                .map(resTo2).toPropertyWhenPresent("resTo2", record::getResTo2)
                .map(resLive).toPropertyWhenPresent("resLive", record::getResLive)
                .map(resWeekend).toPropertyWhenPresent("resWeekend", record::getResWeekend)
                .map(resOverride).toPropertyWhenPresent("resOverride", record::getResOverride)
                .map(share1).toPropertyWhenPresent("share1", record::getShare1)
                .map(share2).toPropertyWhenPresent("share2", record::getShare2)
                .map(gwt).toPropertyWhenPresent("gwt", record::getGwt)
                .map(stopsAllowed).toPropertyWhenPresent("stopsAllowed", record::getStopsAllowed)
                .map(stopWt).toPropertyWhenPresent("stopWt", record::getStopWt)
                .map(carPhone).toPropertyWhenPresent("carPhone", record::getCarPhone)
                .map(phonePolicy).toPropertyWhenPresent("phonePolicy", record::getPhonePolicy)
                .map(drGrade).toPropertyWhenPresent("drGrade", record::getDrGrade)
                .map(smoking).toPropertyWhenPresent("smoking", record::getSmoking)
                .map(airportPolicy).toPropertyWhenPresent("airportPolicy", record::getAirportPolicy)
                .map(airportWtCus).toPropertyWhenPresent("airportWtCus", record::getAirportWtCus)
                .map(airportWtNotCus).toPropertyWhenPresent("airportWtNotCus", record::getAirportWtNotCus)
                .map(salesman1).toPropertyWhenPresent("salesman1", record::getSalesman1)
                .map(salesman2).toPropertyWhenPresent("salesman2", record::getSalesman2)
                .map(salesman1Comm3).toPropertyWhenPresent("salesman1Comm3", record::getSalesman1Comm3)
                .map(salesman2Comm3).toPropertyWhenPresent("salesman2Comm3", record::getSalesman2Comm3)
                .map(serviceFeeA).toPropertyWhenPresent("serviceFeeA", record::getServiceFeeA)
                .map(compReq1).toPropertyWhenPresent("compReq1", record::getCompReq1)
                .map(compReq2).toPropertyWhenPresent("compReq2", record::getCompReq2)
                .map(compReq3).toPropertyWhenPresent("compReq3", record::getCompReq3)
                .map(compReq4).toPropertyWhenPresent("compReq4", record::getCompReq4)
                .map(compReq5).toPropertyWhenPresent("compReq5", record::getCompReq5)
                .map(compReq6).toPropertyWhenPresent("compReq6", record::getCompReq6)
                .map(compLen1).toPropertyWhenPresent("compLen1", record::getCompLen1)
                .map(compLen2).toPropertyWhenPresent("compLen2", record::getCompLen2)
                .map(compLen3).toPropertyWhenPresent("compLen3", record::getCompLen3)
                .map(compLen4).toPropertyWhenPresent("compLen4", record::getCompLen4)
                .map(compLen5).toPropertyWhenPresent("compLen5", record::getCompLen5)
                .map(compLen6).toPropertyWhenPresent("compLen6", record::getCompLen6)
                .map(compPic1).toPropertyWhenPresent("compPic1", record::getCompPic1)
                .map(compPic2).toPropertyWhenPresent("compPic2", record::getCompPic2)
                .map(compPic3).toPropertyWhenPresent("compPic3", record::getCompPic3)
                .map(compPic4).toPropertyWhenPresent("compPic4", record::getCompPic4)
                .map(compPic5).toPropertyWhenPresent("compPic5", record::getCompPic5)
                .map(compPic6).toPropertyWhenPresent("compPic6", record::getCompPic6)
                .map(compVer1).toPropertyWhenPresent("compVer1", record::getCompVer1)
                .map(compVer2).toPropertyWhenPresent("compVer2", record::getCompVer2)
                .map(compVer3).toPropertyWhenPresent("compVer3", record::getCompVer3)
                .map(compVer4).toPropertyWhenPresent("compVer4", record::getCompVer4)
                .map(compVer5).toPropertyWhenPresent("compVer5", record::getCompVer5)
                .map(compVer6).toPropertyWhenPresent("compVer6", record::getCompVer6)
                .map(ccNo1).toPropertyWhenPresent("ccNo1", record::getCcNo1)
                .map(ccNo2).toPropertyWhenPresent("ccNo2", record::getCcNo2)
                .map(ccExp1).toPropertyWhenPresent("ccExp1", record::getCcExp1)
                .map(ccExp2).toPropertyWhenPresent("ccExp2", record::getCcExp2)
                .map(ccType1).toPropertyWhenPresent("ccType1", record::getCcType1)
                .map(ccType2).toPropertyWhenPresent("ccType2", record::getCcType2)
                .map(addressCounter).toPropertyWhenPresent("addressCounter", record::getAddressCounter)
                .map(company).toPropertyWhenPresent("company", record::getCompany)
                .map(vipByName).toPropertyWhenPresent("vipByName", record::getVipByName)
                .map(reqVc).toPropertyWhenPresent("reqVc", record::getReqVc)
                .map(reqCc).toPropertyWhenPresent("reqCc", record::getReqCc)
                .map(reqVcOrVip).toPropertyWhenPresent("reqVcOrVip", record::getReqVcOrVip)
                .map(issueVoucher).toPropertyWhenPresent("issueVoucher", record::getIssueVoucher)
                .map(reqValidVcNo).toPropertyWhenPresent("reqValidVcNo", record::getReqValidVcNo)
                .map(pricingTheory).toPropertyWhenPresent("pricingTheory", record::getPricingTheory)
                .map(graceWt).toPropertyWhenPresent("graceWt", record::getGraceWt)
                .map(compLen1Min).toPropertyWhenPresent("compLen1Min", record::getCompLen1Min)
                .map(compLen2Min).toPropertyWhenPresent("compLen2Min", record::getCompLen2Min)
                .map(compLen3Min).toPropertyWhenPresent("compLen3Min", record::getCompLen3Min)
                .map(compLen4Min).toPropertyWhenPresent("compLen4Min", record::getCompLen4Min)
                .map(compLen5Min).toPropertyWhenPresent("compLen5Min", record::getCompLen5Min)
                .map(compLen6Min).toPropertyWhenPresent("compLen6Min", record::getCompLen6Min)
                .map(reqSubAcctId).toPropertyWhenPresent("reqSubAcctId", record::getReqSubAcctId)
                .map(discountPerc).toPropertyWhenPresent("discountPerc", record::getDiscountPerc)
                .map(freeMinutes).toPropertyWhenPresent("freeMinutes", record::getFreeMinutes)
                .map(phonechargePermin).toPropertyWhenPresent("phonechargePermin", record::getPhonechargePermin)
                .map(cashAccount).toPropertyWhenPresent("cashAccount", record::getCashAccount)
                .map(billingCycleDays).toPropertyWhenPresent("billingCycleDays", record::getBillingCycleDays)
                .map(discountType).toPropertyWhenPresent("discountType", record::getDiscountType)
                .map(phnchargePerminLocal).toPropertyWhenPresent("phnchargePerminLocal", record::getPhnchargePerminLocal)
                .map(phnchargePerminLongd).toPropertyWhenPresent("phnchargePerminLongd", record::getPhnchargePerminLongd)
                .map(phnchargePerminIntl).toPropertyWhenPresent("phnchargePerminIntl", record::getPhnchargePerminIntl)
                .map(compreq1Display).toPropertyWhenPresent("compreq1Display", record::getCompreq1Display)
                .map(compreq2Display).toPropertyWhenPresent("compreq2Display", record::getCompreq2Display)
                .map(compreq3Display).toPropertyWhenPresent("compreq3Display", record::getCompreq3Display)
                .map(compreq4Display).toPropertyWhenPresent("compreq4Display", record::getCompreq4Display)
                .map(compreq5Display).toPropertyWhenPresent("compreq5Display", record::getCompreq5Display)
                .map(compreq6Display).toPropertyWhenPresent("compreq6Display", record::getCompreq6Display)
                .map(stNo).toPropertyWhenPresent("stNo", record::getStNo)
                .map(serviceFeeB).toPropertyWhenPresent("serviceFeeB", record::getServiceFeeB)
                .map(serviceFeePrtFmt).toPropertyWhenPresent("serviceFeePrtFmt", record::getServiceFeePrtFmt)
                .map(graceStopWt).toPropertyWhenPresent("graceStopWt", record::getGraceStopWt)
                .map(wtChargePerHr).toPropertyWhenPresent("wtChargePerHr", record::getWtChargePerHr)
                .map(stopWtChargePerHr).toPropertyWhenPresent("stopWtChargePerHr", record::getStopWtChargePerHr)
                .map(stopopenifnon0fare).toPropertyWhenPresent("stopopenifnon0fare", record::getStopopenifnon0fare)
                .map(disablestopautoopen).toPropertyWhenPresent("disablestopautoopen", record::getDisablestopautoopen)
                .map(tipPerc).toPropertyWhenPresent("tipPerc", record::getTipPerc)
                .map(displayServiceFee).toPropertyWhenPresent("displayServiceFee", record::getDisplayServiceFee)
                .map(callBack).toPropertyWhenPresent("callBack", record::getCallBack)
                .map(internet).toPropertyWhenPresent("internet", record::getInternet)
                .map(vipLabel).toPropertyWhenPresent("vipLabel", record::getVipLabel)
                .map(vipLabelVer).toPropertyWhenPresent("vipLabelVer", record::getVipLabelVer)
                .map(verifyCc).toPropertyWhenPresent("verifyCc", record::getVerifyCc)
                .map(authPersReq).toPropertyWhenPresent("authPersReq", record::getAuthPersReq)
                .map(servicePercentage).toPropertyWhenPresent("servicePercentage", record::getServicePercentage)
                .map(taxExempt).toPropertyWhenPresent("taxExempt", record::getTaxExempt)
                .map(printSubaddress).toPropertyWhenPresent("printSubaddress", record::getPrintSubaddress)
                .map(printDiffinvno).toPropertyWhenPresent("printDiffinvno", record::getPrintDiffinvno)
                .map(vehicleGrade).toPropertyWhenPresent("vehicleGrade", record::getVehicleGrade)
                .map(applySurcharge).toPropertyWhenPresent("applySurcharge", record::getApplySurcharge)
                .map(paymentType).toPropertyWhenPresent("paymentType", record::getPaymentType)
                .map(salesman3Comm3).toPropertyWhenPresent("salesman3Comm3", record::getSalesman3Comm3)
                .map(salesman4Comm4).toPropertyWhenPresent("salesman4Comm4", record::getSalesman4Comm4)
                .map(meetGreet).toPropertyWhenPresent("meetGreet", record::getMeetGreet)
                .map(reservation).toPropertyWhenPresent("reservation", record::getReservation)
                .map(reservationOt).toPropertyWhenPresent("reservationOt", record::getReservationOt)
                .map(graceReseyWt).toPropertyWhenPresent("graceReseyWt", record::getGraceReseyWt)
                .map(reseyWtChargePerHr).toPropertyWhenPresent("reseyWtChargePerHr", record::getReseyWtChargePerHr)
                .map(yearGreaterThan).toPropertyWhenPresent("yearGreaterThan", record::getYearGreaterThan)
                .map(greaterThan).toPropertyWhenPresent("greaterThan", record::getGreaterThan)
                .map(businessClass).toPropertyWhenPresent("businessClass", record::getBusinessClass)
                .map(deductibleAmt).toPropertyWhenPresent("deductibleAmt", record::getDeductibleAmt)
                .map(emailAddress).toPropertyWhenPresent("emailAddress", record::getEmailAddress)
                .map(emailNotification).toPropertyWhenPresent("emailNotification", record::getEmailNotification)
                .map(lastDate).toPropertyWhenPresent("lastDate", record::getLastDate)
                .map(acctIdToReffer).toPropertyWhenPresent("acctIdToReffer", record::getAcctIdToReffer)
                .map(otSurchargeAmt).toPropertyWhenPresent("otSurchargeAmt", record::getOtSurchargeAmt)
                .map(meetGreetAmt).toPropertyWhenPresent("meetGreetAmt", record::getMeetGreetAmt)
                .map(displayOtSurcharge).toPropertyWhenPresent("displayOtSurcharge", record::getDisplayOtSurcharge)
                .map(displayMGAmt).toPropertyWhenPresent("displayMGAmt", record::getDisplayMGAmt)
                .map(vchPerPage).toPropertyWhenPresent("vchPerPage", record::getVchPerPage)
                .map(authPersValidate).toPropertyWhenPresent("authPersValidate", record::getAuthPersValidate)
                .map(stNoNong).toPropertyWhenPresent("stNoNong", record::getStNoNong)
                .map(userName).toPropertyWhenPresent("userName", record::getUserName)
                .map(activeFlag).toPropertyWhenPresent("activeFlag", record::getActiveFlag)
                .map(activeDate).toPropertyWhenPresent("activeDate", record::getActiveDate)
                .map(contectName).toPropertyWhenPresent("contectName", record::getContectName)
                .map(invoiceName).toPropertyWhenPresent("invoiceName", record::getInvoiceName)
                .map(landmark).toPropertyWhenPresent("landmark", record::getLandmark)
                .map(fapiao).toPropertyWhenPresent("fapiao", record::getFapiao)
                .map(advanceInfo).toPropertyWhenPresent("advanceInfo", record::getAdvanceInfo)
                .map(vipFlag).toPropertyWhenPresent("vipFlag", record::getVipFlag)
                .map(vip2Flag).toPropertyWhenPresent("vip2Flag", record::getVip2Flag)
                .map(manager).toPropertyWhenPresent("manager", record::getManager)
                .map(managerComm).toPropertyWhenPresent("managerComm", record::getManagerComm)
                .map(opr).toPropertyWhenPresent("opr", record::getOpr)
                .map(oprComm).toPropertyWhenPresent("oprComm", record::getOprComm)
                .map(advanceRemind).toPropertyWhenPresent("advanceRemind", record::getAdvanceRemind)
                .map(maintenanceMan).toPropertyWhenPresent("maintenanceMan", record::getMaintenanceMan)
                .map(maintenanceStatus).toPropertyWhenPresent("maintenanceStatus", record::getMaintenanceStatus)
                .map(maintenanceDateTime).toPropertyWhenPresent("maintenanceDateTime", record::getMaintenanceDateTime)
                .map(maintenanceDeep).toPropertyWhenPresent("maintenanceDeep", record::getMaintenanceDeep)
                .map(payComment).toPropertyWhenPresent("payComment", record::getPayComment)
                .map(registerComment).toPropertyWhenPresent("registerComment", record::getRegisterComment)
                .map(selfPrivilege).toPropertyWhenPresent("selfPrivilege", record::getSelfPrivilege)
                .map(selfOrderMailcc).toPropertyWhenPresent("selfOrderMailcc", record::getSelfOrderMailcc)
                .map(selfOrderGuarantee).toPropertyWhenPresent("selfOrderGuarantee", record::getSelfOrderGuarantee)
                .map(confirmFlag).toPropertyWhenPresent("confirmFlag", record::getConfirmFlag)
                .map(rebatePercent).toPropertyWhenPresent("rebatePercent", record::getRebatePercent)
                .map(rebateAmount).toPropertyWhenPresent("rebateAmount", record::getRebateAmount)
                .map(cardLevel).toPropertyWhenPresent("cardLevel", record::getCardLevel)
                .map(selfDiscount).toPropertyWhenPresent("selfDiscount", record::getSelfDiscount)
                .map(acctSmsOrder).toPropertyWhenPresent("acctSmsOrder", record::getAcctSmsOrder)
                .map(needPrice).toPropertyWhenPresent("needPrice", record::getNeedPrice)
                .map(needSms).toPropertyWhenPresent("needSms", record::getNeedSms)
                .map(needEmail).toPropertyWhenPresent("needEmail", record::getNeedEmail)
                .map(englishCustomer).toPropertyWhenPresent("englishCustomer", record::getEnglishCustomer)
                .map(cartypePlus).toPropertyWhenPresent("cartypePlus", record::getCartypePlus)
                .map(insuranceAssure).toPropertyWhenPresent("insuranceAssure", record::getInsuranceAssure)
                .map(guaranteeAssure).toPropertyWhenPresent("guaranteeAssure", record::getGuaranteeAssure)
                .map(serviceComment).toPropertyWhenPresent("serviceComment", record::getServiceComment)
                .map(affFapiao).toPropertyWhenPresent("affFapiao", record::getAffFapiao)
                .map(attnname).toPropertyWhenPresent("attnname", record::getAttnname)
                .map(attnphoneext).toPropertyWhenPresent("attnphoneext", record::getAttnphoneext)
                .map(attnphone).toPropertyWhenPresent("attnphone", record::getAttnphone)
                .map(attnmobile).toPropertyWhenPresent("attnmobile", record::getAttnmobile)
                .map(attnemail).toPropertyWhenPresent("attnemail", record::getAttnemail)
                .map(deciname).toPropertyWhenPresent("deciname", record::getDeciname)
                .map(deciphoneext).toPropertyWhenPresent("deciphoneext", record::getDeciphoneext)
                .map(deciphone).toPropertyWhenPresent("deciphone", record::getDeciphone)
                .map(decimobile).toPropertyWhenPresent("decimobile", record::getDecimobile)
                .map(deciemail).toPropertyWhenPresent("deciemail", record::getDeciemail)
                .map(email4).toPropertyWhenPresent("email4", record::getEmail4)
                .map(email3).toPropertyWhenPresent("email3", record::getEmail3)
                .map(billingperiod).toPropertyWhenPresent("billingperiod", record::getBillingperiod)
                .map(financename).toPropertyWhenPresent("financename", record::getFinancename)
                .map(financephone).toPropertyWhenPresent("financephone", record::getFinancephone)
                .map(industryclass).toPropertyWhenPresent("industryclass", record::getIndustryclass)
                .map(businessproperty).toPropertyWhenPresent("businessproperty", record::getBusinessproperty)
                .map(pricetype).toPropertyWhenPresent("pricetype", record::getPricetype)
                .map(parentid).toPropertyWhenPresent("parentid", record::getParentid)
                .map(bookState).toPropertyWhenPresent("bookState", record::getBookState)
                .map(bookCity).toPropertyWhenPresent("bookCity", record::getBookCity)
                .map(bookStName).toPropertyWhenPresent("bookStName", record::getBookStName)
                .map(bookStNoNong).toPropertyWhenPresent("bookStNoNong", record::getBookStNoNong)
                .map(bookStNo).toPropertyWhenPresent("bookStNo", record::getBookStNo)
                .map(bookLandmark).toPropertyWhenPresent("bookLandmark", record::getBookLandmark)
                .map(bookApt).toPropertyWhenPresent("bookApt", record::getBookApt)
                .map(clearingremarks).toPropertyWhenPresent("clearingremarks", record::getClearingremarks)
                .map(financialnotes).toPropertyWhenPresent("financialnotes", record::getFinancialnotes)
                .map(billrecState).toPropertyWhenPresent("billrecState", record::getBillrecState)
                .map(billrecCity).toPropertyWhenPresent("billrecCity", record::getBillrecCity)
                .map(billrecStName).toPropertyWhenPresent("billrecStName", record::getBillrecStName)
                .map(billrecStNoNong).toPropertyWhenPresent("billrecStNoNong", record::getBillrecStNoNong)
                .map(billrecStNo).toPropertyWhenPresent("billrecStNo", record::getBillrecStNo)
                .map(billrecLandmark).toPropertyWhenPresent("billrecLandmark", record::getBillrecLandmark)
                .map(billrecApt).toPropertyWhenPresent("billrecApt", record::getBillrecApt)
                .map(billpaState).toPropertyWhenPresent("billpaState", record::getBillpaState)
                .map(billpaCity).toPropertyWhenPresent("billpaCity", record::getBillpaCity)
                .map(billpaStName).toPropertyWhenPresent("billpaStName", record::getBillpaStName)
                .map(billpaStNoNong).toPropertyWhenPresent("billpaStNoNong", record::getBillpaStNoNong)
                .map(billpaStNo).toPropertyWhenPresent("billpaStNo", record::getBillpaStNo)
                .map(billpaLandmark).toPropertyWhenPresent("billpaLandmark", record::getBillpaLandmark)
                .map(billpaApt).toPropertyWhenPresent("billpaApt", record::getBillpaApt)
                .map(fapiaoDivide).toPropertyWhenPresent("fapiaoDivide", record::getFapiaoDivide)
                .map(achievementInclude).toPropertyWhenPresent("achievementInclude", record::getAchievementInclude)
                .map(settlement).toPropertyWhenPresent("settlement", record::getSettlement)
                .map(creditRating).toPropertyWhenPresent("creditRating", record::getCreditRating)
                .map(verificationcycle).toPropertyWhenPresent("verificationcycle", record::getVerificationcycle)
                .map(fuelsurcharge).toPropertyWhenPresent("fuelsurcharge", record::getFuelsurcharge)
                .map(fapiaoType).toPropertyWhenPresent("fapiaoType", record::getFapiaoType)
                .map(vinZzs).toPropertyWhenPresent("vinZzs", record::getVinZzs)
                .map(addrZzs).toPropertyWhenPresent("addrZzs", record::getAddrZzs)
                .map(phoneZzs).toPropertyWhenPresent("phoneZzs", record::getPhoneZzs)
                .map(bankZzs).toPropertyWhenPresent("bankZzs", record::getBankZzs)
                .map(banknoZzs).toPropertyWhenPresent("banknoZzs", record::getBanknoZzs)
                .map(taxPercent).toPropertyWhenPresent("taxPercent", record::getTaxPercent)
                .map(loginFlag).toPropertyWhenPresent("loginFlag", record::getLoginFlag)
                .map(selfSettlement).toPropertyWhenPresent("selfSettlement", record::getSelfSettlement)
                .map(acctCity).toPropertyWhenPresent("acctCity", record::getAcctCity)
                .map(regprice).toPropertyWhenPresent("regprice", record::getRegprice)
                .map(meetgreet).toPropertyWhenPresent("meetgreet", record::getMeetgreet)
                .map(innerCarFlag).toPropertyWhenPresent("innerCarFlag", record::getInnerCarFlag)
                .map(ispobill).toPropertyWhenPresent("ispobill", record::getIspobill)
                .map(salesmanblock).toPropertyWhenPresent("salesmanblock", record::getSalesmanblock)
                .map(settlementblock).toPropertyWhenPresent("settlementblock", record::getSettlementblock)
                .map(iselectronicinvoice).toPropertyWhenPresent("iselectronicinvoice", record::getIselectronicinvoice)
                .map(servicetype).toPropertyWhenPresent("servicetype", record::getServicetype)
                .map(isnodispatch).toPropertyWhenPresent("isnodispatch", record::getIsnodispatch)
                .build()
                .render(RenderingStrategy.MYBATIS3));
    }





}